How to: Reformat a chart.
Solution:
Select the chart, select the 'Format' menu and select 'AutoFormat...'.
1) Select the desired chart. (A striped border with handles appears around the chart.)
a) If the chart is embedded on the worksheet, double-click on the chart.
b) If the chart is on a separate chart sheet, click the tab for the chart sheet.
2) Select the 'Format' menu and select 'AutoFormat...'. (The AutoFormat dialog box appears.)
AutoFormat dialog box
3) Select the appropriate radio button in the 'Formats Used' group.
NOTE 1: Select the 'Built-in' radio button to view chart formats that are predefined in Excel.
NOTE 2: Select the 'User-Defined' radio button to view formats created by users.
4) Select the appropriate gallery from the 'Galleries' list box. (The Formats group displays all the formats available for the selected gallery.)
5) Select the desired format from the 'Format' group.
6) Click 'OK'.
